//  Delete the row in the table in the database from Java API.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.ResultSet;

class Main {
    private static Connection con;
    private static int rows_affected;

    public static void main(String[] args) {
        
        try{
            Class.forName("com.mysql.cj.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
            
            Statement st = con.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE);
            String sql = "DELETE FROM students";
            
            rows_affected = st.executeUpdate(sql);
            System.out.println("Numbers of rows deleted : "+rows_affected);
            
            //telling user that he is deleting from an empty table.
            ResultSet rs =  st.executeQuery("SELECT * FROM students");
            if(!rs.next())
            System.out.println("--------   Hey User, Your table is empty.  --------");
        }
        catch(ClassNotFoundException c)
        {
            c.printStackTrace();
        }
        catch(SQLException s)
        {
            s.printStackTrace();
        }

        if(con!=null) {
            try {
                con.close();
            }
            catch(SQLException sql_e) {
                sql_e.printStackTrace();
            }
        }
    }
}